• SQL Script for SQL Server Table and Column Properties

    Updated: 2023-09-29 05:00:00
    In this article, we look at a set of T-SQL code that can be used to profile all the tables and columns in a SQL Server database.

  • T-SQL Fundamentals: Controlling Duplicates

    Updated: 2023-09-28 18:37:41
    When people start learning a new field, for example T-SQL, it’s tempting to spend very little time trying to understand the fundamentals of the field so that you can quickly get to the advanced parts. You might think that you already understand what certain ideas, concepts and terms mean, so you don’t necessarily see the … The post T-SQL Fundamentals: Controlling Duplicates appeared first on Simple Talk.

  • Azure Databricks Tables - Delta Lake, Hive Metastore, TempViews, Managed, External

    Updated: 2023-09-28 05:00:00
    In this article, learn about the different tables that can be created using Azure Databricks with a dive deep into the importance of Delta Lake tables.

  • Snowflake SELECT Statement Capabilities

    Updated: 2023-09-28 05:00:00
    This article addresses the SQL SELECT statement and sheds light on some of its unique features in Snowflake.

  • Microsoft Fabric and the Delta Tables Secrets

    Updated: 2023-09-27 20:02:13
    Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained in my introduction to Microsoft Fabric. Either if you use lakehouses, data warehouses, or even datasets, all the data is stored in the OneLake. OneLake uses Delta Tables as storage. In this way, we need to be aware … The post Microsoft Fabric and the Delta Tables Secrets appeared first on Simple Talk.

  • Exploring the Split Columns Option in Power Query Editor for Power BI

    Updated: 2023-09-27 05:00:00
    Learn how to use Power BI and Power Query to split up data from one column into multiple columns using various ways of delimiting the data.

  • Know Your Business Data Verification Solution with Melissa Personator Identity Global

    Updated: 2023-09-27 05:00:00
    Learn how to meet Know Your Business Data Verification rules with Melissa Personator Identity Global to prevent fraud or money-laundering and meet legal regulations.

  • Working with AWS Athena - Configuration, Query Data, Create Tables and Views

    Updated: 2023-09-26 05:00:00
    In this article, we look at how to use AWS Athena to query data as well as create tables and views when working with Athena.

  • SQL Server Row Level Security Deep Dive. Part 5 – RLS Attacks

    Updated: 2023-09-25 00:18:31
    As mentioned in previous sections, RLS is an addition to security and should not be used as the primary method to limit access to data. It is a supplementary layer, useful in specific scenarios. There are also instances where RLS can be defeated by an unauthorized user. The attacks listed below are broken down into … The post SQL Server Row Level Security Deep Dive. Part 5 – RLS Attacks appeared first on Simple Talk.

  • MySQL joins

    Updated: 2023-09-25 00:00:29
    Tables in a MySQL database are commonly related to one another, often in multiple ways, and it is only by linking the tables together that you can derive meaningful information from the data. To connect these tables together, you can use the JOIN clause, which you include in your SELECT, DELETE, or UPDATE statements. The … The post MySQL joins appeared first on Simple Talk.

  • SQL Pivot Like a Pro

    Updated: 2023-09-22 05:00:00
    In this article, we look at ways to pivot and unpivot data using T-SQL code to transform data into rows and columns.

  • How to clone Oracle Home in 10g/11g/12c/19c/23c

    Updated: 2023-09-21 08:10:00
    Oracle has different steps based on the version How to clone Oracle Home in 10g/11g/12c Prepare steps 1) On the source Create a tar file of the Oracle Home /u001/app/oracle/product/12.1.0/dbhome_1 $cd /u001/app/oracle/product/12.1.0/$ tar -cvf dbhome_1.tar dbhome_1 2) scp this tar file to the target machine and untar the file scp dbhome_1.tar LINUX1:/u001/appl/oracle//product/12.1.0Login to LINUX1cd /u001/appl/oracle//product/12.1.0tar […] The post How to clone Oracle Home in 10g/11g/12c/19c/23c appeared first on Techgoeasy.

  • Microsoft Fabric: Checking and Fixing Tables V-Order Optimization

    Updated: 2023-09-20 17:00:16
    Download the notebook used on this blog I explained in a previous article how the Tables in a lakehouse are V-Order optimized. We noticed this configuration depends on our settings, which can be enabled or not. One question remains: How could we check if the tables are V-Order optimized or not? The tables we will … The post Microsoft Fabric: Checking and Fixing Tables V-Order Optimization appeared first on Simple Talk.

  • How to find the FND_FILE output of the running concurrent request

    Updated: 2023-09-20 07:55:52
    We generally write FND_FILE statements in concurrent programs for debugging, logs, and various other messages These are visible in Concurrent request logs and out once the concurrent program completes only If we want to see the logs and out for the running concurrent request, then we need to find the temporary log and out file […] The post How to find the FND_FILE output of the running concurrent request appeared first on Techgoeasy.

  • srvctl commands in Oracle

    Updated: 2023-09-20 05:47:00
    srvctl commands is an important tool to manage the Oracle database in the RAC environment and Oracle restarts env(Single node env with ASM). This can be used to stop, start, find status, and other things in the cluster or the server. Let’s review those command srvctl commands srvctl is a utility in $ORACLE_HOME/bin and it […] The post srvctl commands in Oracle appeared first on Techgoeasy.

  • Rounding Numbers to the Nearest Integer with T-SQL

    Updated: 2023-09-20 05:00:00
    In this article, we look at how to use T-SQL to round to the nearest integer using round, ceiling, floor, and the banker's rounding rule.

  • Parameter Sniffing Issue with Temporary Tables in SQL Server 2022

    Updated: 2023-09-20 05:00:00
    In this article, we look at how parameter sniffing can still be an issue in SQL Server 2022 when using temporary tables and one way to resolve the issue.

  • How to Upgrade SQL Server from Evaluation Edition to Standard or Enterprise

    Updated: 2023-09-19 05:00:00
    Learn how to upgrade SQL Server from the Evaluation edition to other SQL Server editions like Standard or Enterprise.

  • SQL Athena Introduction - How it works, Use Cases and Advantages

    Updated: 2023-09-19 05:00:00
    Learn about Amazon Athena, how it works, why you would use it, and some of the advantages of Athena over traditional relational databases.

  • Alternatives To SQL Server 2022 Built-in function GREATEST

    Updated: 2023-09-18 20:53:28
    If you haven’t already heard, SQL Server 2022  introduced a new built-in system function called GREATEST. Simply put, it is to a set of columns, variables, expressions etc. what the MAX function is to a set of values (i.e., rows) of a single column or expression. The opposite of GREATEST function is LEAST function which … The post Alternatives To SQL Server 2022 Built-in function GREATEST appeared first on Simple Talk.

  • Microsoft Fabric Personas

    Updated: 2023-09-18 05:00:00
    Learn about personas when working with Microsoft Fabric to help filter the options and features that best meet your needs.

  • Configuring a Virtual Private Cloud (VPC) for Google Cloud Platform (GCP)

    Updated: 2023-09-18 05:00:00
    Learn how to use the Google Cloud Platform to share a VPC for multiple projects and how we can connect to GCP from on-premises.

  • SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives

    Updated: 2023-09-17 18:58:41
    One of the primary reasons to implement RLS is to facilitate reporting and ease the administrative burden. This section covers some considerations for using RLS with the primary Microsoft reporting engines and gives you an idea of things to look for in your reporting engine. Some anti patterns and alternatives to RLS are also examined. … The post SQL Server Row Level Security Deep Dive. Part 4 – Integration, Anti-patterns, and Alternatives appeared first on Simple Talk.

  • SQL Server Static Data Masking with DataVeil

    Updated: 2023-09-15 05:00:00
    Learn how to use production-like data for testing and development, but mask sensitive data quickly and efficiently with DataVeil.

  • Top SQL Patch Queries in Oracle Database

    Updated: 2023-09-14 06:25:00
    Here are some of the top SQL Patch Queries in Oracle Database Query to Query to find the hints associated with a SQL Patch select cast(extractvalue(value(x), '/hint') as varchar2(500)) as outline_hintsfrom xmltable('/outline_data/hint'passing (select xmltype(comp_data) xmlfrom sys.sqlobj$datawhere signature = select EXACT_MATCHING_SIGNATURE from v$sql where sql_id = '&SQL_ID';)) x; How to find all the SQL_PATCH in the […] The post Top SQL Patch Queries in Oracle Database appeared first on Techgoeasy.

  • Large Language Models (LLMs) to train artificial intelligence (AI) tools such as ChatGPT

    Updated: 2023-09-14 05:00:00
    Learn about Large Language Models (LLMs) and how they are used to train artificial intelligence (AI) tools such as ChatGPT.

  • how to find if the sql is using the SQL Patch

    Updated: 2023-09-13 06:12:00
    When we implement the SQL Patch for the statement, we would also like to confirm if the sql has started using the SQL Patch or not. We can use the below query to find out if the sql is using the SQL Patch How to find if the sql is using the SQL Patch col […] The post how to find if the sql is using the SQL Patch appeared first on Techgoeasy.

  • SQL Server Database Snapshots for Rapid Restores

    Updated: 2023-09-13 05:00:00
    In this article, we look at using SQL Server database snapshots to quickly revert a database to a prior state to streamline testing and development.

  • How to create SQL Patch for sql tuning in Oracle

    Updated: 2023-09-12 10:37:00
    SQL patch is a new feature from 12c onwards where we can insert hints into the sql statement using this feature. This is particularly useful when the application code cannot be modified and hints are providing the performance benefits. We have other tools like Sql profile, Sql plan baseline available also to to tune the […] The post How to create SQL Patch for sql tuning in Oracle appeared first on Techgoeasy.

  • Query Performance Degraded after Rebuilding Clustered Columnstore Index

    Updated: 2023-09-12 05:00:00
    In this article, we look at why SQL Server performance degraded after rebuilding a Clustered Columnstore Index and how to resolve it.

  • Easy and Cost Effective way to Encrypt Every SQL Server Database

    Updated: 2023-09-12 05:00:00
    Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.

  • Build Clustered Column Chart and Clustered Bar Chart in Power BI Desktop

    Updated: 2023-09-11 05:00:00
    Learn how to create clustered column charts and clustered bar charts in Power BI along with why you would choose one over the other.

  • Deploy and Secure Cloud SQL Database on Google Cloud Platform (GCP)

    Updated: 2023-09-08 05:00:00
    In this article, learn how to deploy and secure a SQL Server database instance as a managed service on the Google Cloud Platform.

  • Compare SQL Server Offerings by Top Cloud Providers - Azure, AWS and Google Cloud

    Updated: 2023-09-07 05:00:00
    In this article, we look at the similarities and differences between what is offered for SQL Server for Azure, AWS, and Google Cloud.

  • Import JSON Files into Databricks Spark and import Excel files into Databricks

    Updated: 2023-09-06 05:00:00
    This article teaches us how to import JSON files into Databricks Spark as well as how to import Excel files into Databricks.

  • Using NOLOCK to Resolve SQL Server Blocking Issues

    Updated: 2023-09-05 05:00:00
    In this article, we look at troubleshooting a SQL Server blocking issue and how the use of NOLOCK was able to resolve the problem.

Current Feed Items | Previous Months Items

Aug 2023 | Jul 2023 | Jun 2023 | May 2023 | Apr 2023 | Mar 2023